/****** Object:  Stored Procedure dbo.CGO_AccountDelete    Script Date: Monday, March 07, 2011 ******/
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'dbo.CGO_AccountDelete')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) 
  DROP PROCEDURE dbo.CGO_AccountDelete
GO

/* -------------------------------------------------------------------------------------
/   AccountDelete
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE dbo.CGO_AccountDelete
  @PortalID INT,
  @UserID INT  
AS 
  DELETE  FROM dbo.CGO_Account
  WHERE   UserID = @UserID
          AND PortalID = @PortalID
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO